Data Warehouse Design and Implementation Based on Star Schema vs. Snowflake Schema
نویسندگان
چکیده
منابع مشابه
Why is the snowflake schema a good data warehouse design?
Database design for data warehouses is based on the notion of the snowflake schema and its important special case, the star schema. The snowflake schema represents a dimensional model which is composed of a central fact table and a set of constituent dimension tables which can be further broken up into subdimension tables. We formalise the concept of a snowflake schema in terms of an acyclic da...
متن کاملData Warehouse Schema Design
A data warehouse is an integrated database primarily used in organizational decision making. Although the deployment of data warehouses is current practice in modern information technology landscapes, the methodical schema design for such databases has only been studied cursorily. In this paper we pursue schema design for data warehouses in the spirit of classical database design, organized as ...
متن کاملQuality-oriented Data Warehouse Schema Design
Während sich der klassische, phasenorientierte Schemaentwurfsprozess für operationale Datenbanken dank klar definierter Ziele und Qualitätsanforderungen bewährt hat, wird Schemaentwurf im Data-Warehouse-Kontext oftmals ad hoc basierend auf Erfahrungswerten betrieben. In diesem Betrag versuchen wir, die Frage, ob DataWarehouse-Entwurf von klassischem Datenbankentwurf lernen kann, (positiv) zu be...
متن کاملData Warehouse Design: A Schema-Transformation Approach
This paper addresses DW design problems, with the goal of improving the DW logical design process. Some of the existing work in transformation oriented methodologies for DW design construct the DW starting from an EntityRelationship model of the source database, and arrive to a conceptual or highlevel-logical dimensional model of the DW. We propose a mechanism for obtaining the DW logical schem...
متن کاملAutomating data warehouse conceptual schema design and evaluation
The popularity of data warehouses for analysis of data has grown tremendously, but much of the creation of data warehouses is done manually. We propose and illustrate algorithms for automatic conceptual schema development and evaluation. Our creation algorithm uses an enterprise schema of an operational database as a starting point for source-driven data warehouse schema design. Candidate conce...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: International Journal of Academic Research in Business and Social Sciences
سال: 2019
ISSN: 2222-6990
DOI: 10.6007/ijarbss/v9-i14/6502